Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_9430

R_9430

PhAuctionPackage

PhAuctionPackageItem

AuctionPackageID

 

 

R_9431

R_9431

PhCompany

PhAuctionOffer

DelivererID

 

 

R_9432

R_9432

PhAuction

PhAuctionOffer

AuctionID

 

 

R_9433

R_9433

VATRate

PhAuctionPackageOfferItem

VatRateId

 

 

R_9434

R_9434

PhCompany

PhAuctionPackageOfferItem

ProducerID

 

 

R_9435

R_9435

PhAuctionPackageItem

PhAuctionPackageOfferItem

AuctionPackageItemID

 

 

R_9436

R_9436

PhStItem

PhAuctionPackageOfferItem

StockItemID

 

 

R_9437

R_9437

PhAuctionOffer

PhAuctionPackageOffer

AuctionOfferID

 

 

R_9438

R_9438

PhAuctionPackage

PhAuctionPackageOffer

AuctionPackageID

 

 

R_9439

R_9439

PhAuctionPackageOfferStatus

PhAuctionPackageOffer

StatusID

 

 

R_9440

R_9440

PhAuctionOfferStatus

PhAuctionOffer

StatusID

 

 

R_9450

R_9450

PhStItem

PhLDrugAliasStockItem

StItemID

 

 

R_9451

R_9451

PhDrugAlias

PhLDrugAliasStockItem

DrugAliasID

 

 

R_9452

R_9452

PhDrugAlias

PhStOrderItem

DrugAliasID

 

 

R_9471

R_9471

PhLot

PhBlockadeLot

LotId

 

 

R_9644

R_9644

PhLotType

PhLotTypeText

LotTypeID

 

 

R_9645

R_9645

PhLotType

PhLot

LotTypeID

 

 

R_9648

R_9648

PhUnit

PhLDrugProdItLotInSt

PresentationUnitId

 

 

R_9661

R_9661

PhTendOffItemType

PhTendOffItemTypeText

TendOffItemTypeID

 

 

R_9713

R_9713

PhStDocItemCorrType

PhStDocItemCorrTypeText

StDocItemCorrTypeID

 

 

R_9714

R_9714

PhStDocItem

PhStDocItemCorrelation

FromStDocItemId

 

 

R_9715

R_9715

PhStDocItem

PhStDocItemCorrelation

ToStDocItemId

 

 

R_9716

R_9716

PhStDocItemCorrType

PhStDocItemCorrelation

StDocItemCorrTypeID

 

 

R_9717

R_9717

PhTendOffItemType

PhTenderOfferItem

TendOffItemTypeID

 

 

R_9798

R_9798

PhPack

PhLPackVatRate

PackID

 

 

R_9799

R_9799

VATRate

PhLPackVatRate

VatRateID

 

 

R_9806

R_9806

REVINFO

phdrughist

rev

 

 

R_9807

R_9807

REVINFO

PhResourceHist

rev

 

 

R_9808

R_9808

REVINFO

PhPackHist

rev

 

 

R_9809

R_9809

REVINFO

PHSTITEMGROUPASSOCHIST

rev

 

 

R_9810

R_9810

REVINFO

phstitemhist

rev

 

 

R_9811

R_9811

REVINFO

PhStItemStItemGroupHist

rev

 

 

R_9812

R_9812

REVINFO

PhLPackVatRateHist

rev

 

 

R_9813

R_9813

REVINFO

PhLPackUnitHist

rev

 

 

R_9814

R_9814

REVINFO

PhUnitMapperHist

rev

 

 

R_9815

R_9815

REVINFO

PhLStItemStPlHist

rev

 

 

R_9816

R_9816

REVINFO

PHDRUGATCHIST

Rev

 

 

R_9817

R_9817

REVINFO

PhDrugDrugAtcHist

REV

 

 

R_9818

R_9818

REVINFO

PhDrugDDDhist

rev

 

 

R_9833

R_9833

REVINFO

PhLotHist

REV

 

 

R_9840

R_9840

PhStOrder

PhStockOrderApprovalNo

StOrderID

 

 

R_9841

R_9841

PhStockOrderApprovalNo

PhStOrder

StockOrderApprovalID

 

 

R_9860

R_9860

BenefitPlanContract

PhStDoc

BenefitPlanContractID

 

 

R_9892

R_9892

BenefitPlanContract

PhTradeDocItem

benefitPlanContractId

 

 

R_9893

R_9893

BenefitPlanContract

PhLot

benefitPlanContractId

 

 

R_9894

R_9894

BenefitPlanContract

PhStDocItem

benefitPlanContractId

 

 

R_9895

R_9895

BenefitPlanContract

PhTradeDoc

benefitPlanContractId

 

 

R_9915

R_9915

PhStDocTradeDocRelType

PhStDocTradeDocRelTypeText

StDocTradeDocRelTypeID

 

 

R_9916

R_9916

PhStDoc

PhLStDocTradeDoc

StDocID

 

 

R_9917

R_9917

PhTradeDoc

PhLStDocTradeDoc

TradeDocID

 

 


1  2  3  4  5  6  7  8